class CreateRatings < ActiveRecord::Migration
  def self.up
    create_table :ratings, :options => "ENGINE=MyISAM" do |t|
      t.integer  :drug_id
      t.integer  :score
      t.string   :reason
      t.text     :sideffect_description
      t.text     :comment
      t.string   :sex
      t.integer  :age
      t.integer  :times_taken
      t.integer  :days_taken
      t.datetime :date_added
      t.timestamps
    end
  end

  def self.down
    drop_table :ratings
  end
end
